DataViz Makeover 2

DataViz Makeover 2 for ISSS608: Visual Analytics

1 Critique of Original Visualization

The original visualization is shown below.

1.1 Clarity

1.2 Aesthetic

2 Makeover Design

The makeover design is shown below:

2.1 Clarity

2.2 Aesthetic

3 Proposed Visualization

The makeover visualization on Tableau Public is published here.

4 Step-by-step Guide

  1. Open the downloaded dataset “outputFile.xlsx” in Excel. Remove the text information above and below T1 and T2.

  1. Save the processed dataset and import it into Tableau, drag T1 to the Data Source panel.

  1. Click on the small triangle in the upper right corner of column Variables, select “Split”, then the column Variables is automatically split into two separate columns.

  1. Click on the small triangle in the upper right corner of column Variables, select “Hide” to hide this column. Repeat the same thing for column Varables – Split 2 to hide it as well.

  1. Rename the column Varables – Split 1 as “Country”.

  1. Retain those months between January 2011 and December 2020 and hide all the other month columns.

  1. Select column 2011 Jan, go to the most right side of this table, press “shift” on the keyboard and select column 2020 Dec. Click on the small triangle in the upper right corner of column 2020 Dec, select “Pivot” to pivot these columns to rows.

  1. Rename the column Pivot Field Names as “Month” and the column Pivot Field Values as “Imports”.

  1. Click on “Abc” in the upper left corner of column Month, select “Date” to change the data type of this column from String to Date.

  1. Click on “Abc” in the upper left corner of column Imports, select “Number(decimal)” to change the data type of this column from String to Number.

  1. Go to Worksheet Sheet 1, put Month on Columns, click on the small triangle on the right side and select Day to represent the data according to each day of the year.

  1. Put Imports on Rows, click on the small triangle on the right side and select Measure, choose “Sum” to represent the imports according to sum of the imports.

  1. Put Country to Filters panel, select the 10 countries showed on the original visualization and click on OK.

  1. Put Country on Columns.

  1. Click on Analysis on the navigation bar, select View Data and choose Export All. Name the processed csv file as “Imports by Region” and then click on Save.

  1. Repeat the same operations to process the table T2 to a new csv table “Exports by Region”.

  1. Import the processed dataset Imports by Region and Exports by Region into Tableau.

  1. Click on the small triangle on the right side of “Imports by Region.csv”, select open to build a join relationship.

  1. Drag Exports by Region.csv to the join canvas.

  1. Click the join icon and select the “Add new join clause” dropdown list and then add Day of Month to the join clause.

  1. Rename column Sum of Exports as Exports and column Sum of Imports as Imports.

  1. Click on the “Abc” on the upper left of the two Day of Month columns and change the data type from String to Date.

  1. Hide one Country column and one Day of Month column.

  1. Rename the column Day of Month as Month.

  1. Because in the original dataset, the unit of European Union is Million Dollars while the unit of all the other countries is Thousand Dollars, we need to create a new calculated field to make the value of all these countries in the same unit. Go to Worksheet Sheet 1, click on Analysis on the navigation bar and select “Create Calculated Field”. Create a calculated field called “Imports (Thousand Dollars)” which convert the unit of all countries’ imports to Thousand Dollars.

  1. Repeat the same things to create a calculated field called “Exports (Thousand Dollars)” which convert the unit of all countries’ exports to Thousand Dollars.

  1. Create a calculated field called “Total Trade” which is the summation of imports and exports, then click OK.

  1. Put Imports (Thousand Dollars) on Rows and Exports (Thousand Dollars) on Columns.

  1. Put Country on Detail at the Marks panel.

  1. Put Total Trade on Size at the Marks panel.

  1. Adjust the size to be a little bit larger to make the difference between different countries clearer.

  1. Change the type of mark to be Circle at the Marks panel.

  1. Put Total Trade on Color at the Marks Panel.

  1. Click Color at the Marks Panel and then click Edit Colours. Change the color schema to Red-Blue Diverging and check the Use Full Colour Range check box, then click OK.

  1. Click Color at the Marks Panel and then change the opacity from 100% to 80%. Select the Border dropdown list and add a white border to the circle to make the overlap part to be clear to see.

  1. Create a calculated field called Rank by Imports to calculate the rank of different countries according to their imports.

  1. Create a calculated field called Rank by Exports to calculate the rank of different countries according to their exports.

  1. Put Month on the Pages panel, click the small little triangle on the right side and select month to represent Month by the month of year.

  1. Put Rank by Imports and Rank by Exports on Tooltip.

  1. Click the small triangle on the right side of Rank by Imports and Rank by Exports, go to Compute Using and then select Country.

  1. Click Tooltip on the Marks panel and format the content of tooltip as shown below.

  1. Put Country on Lable and check the check box “Allow lables to overlap other marks”.

  1. Right click on the y-axis and select Add Reference Line. Choose Median for the second dropdown list under Value, select Custom for Lable and format the content of label as Median=Value. Format the reference line as a thin dotted line and change the color to light grey, then click OK.

  1. Repeat the same things to add a reference line on the x-axis.

  1. Click Format on the navigation bar and then select Animations, turn on the switch for animation and set Duration as 2.00 seconds.

  1. Rename the sheet name as “Singapore Merchandise Trade by Region” and the final visualization is done.

5 Derived Insights

  1. We can see that in the early part of this 10-years period, the top trading country of Singapore was Malaysia. However, in around 2015, the total trading value for China started to exceed Malaysia and both the imports and exports show an increasing trend. Since 2018, the deficit with China became more significant.

  1. Since 2018, Singapore started to have more merchandise trade with some west countries like US and EU. With the increase of the total trade value at the same time, the exports of these two countries fluctuate around the median while the imports have a rising trend, which shows Singapore is in deficit with these two countries.

  1. Hong Kong is always a net exporter during this 10-years period. The exports with Hong Kong shows an overall growing trend and between 2019 and 2020 the trade surplus growth is more significant.